Trees Madrid Dataset

Dataset statistics

Number of variables	35
Number of observations	655650
Missing cells	5051403
Missing cells (%)	22.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	175.1 MiB
Average record size in memory	280.0 B

Variable types

CAT	20
NUM	13
UNSUPPORTED	2

Warnings

`common_name` has a high cardinality: 438 distinct values	High cardinality
`description` has a high cardinality: 654440 distinct values	High cardinality
`neighborhood` has a high cardinality: 130 distinct values	High cardinality
`direction_code` has a high cardinality: 68392 distinct values	High cardinality
`serial_number` has a high cardinality: 654407 distinct values	High cardinality
`management_unit` has a high cardinality: 4596 distinct values	High cardinality
`greenarea` has a high cardinality: 3340 distinct values	High cardinality
`specie_abbreviation` has a high cardinality: 472 distinct values	High cardinality
`specie_name` has a high cardinality: 471 distinct values	High cardinality
`label` has a high cardinality: 654408 distinct values	High cardinality
`objectid` is highly correlated with `Unnamed: 0`	High correlation
`Unnamed: 0` is highly correlated with `objectid`	High correlation
`id_neighborhood` is highly correlated with `id_district`	High correlation
`id_district` is highly correlated with `id_neighborhood`	High correlation
`street_type` has 655579 (> 99.9%) missing values	Missing
`streetname` has 655579 (> 99.9%) missing values	Missing
`housenumber` has 655594 (> 99.9%) missing values	Missing
`direction_code` has 444722 (67.8%) missing values	Missing
`zipcode` has 655550 (> 99.9%) missing values	Missing
`id_management_unit` has 423135 (64.5%) missing values	Missing
`management_unit` has 423135 (64.5%) missing values	Missing
`id_greenarea` has 235209 (35.9%) missing values	Missing
`greenarea` has 235275 (35.9%) missing values	Missing
`interference_type` has 628745 (95.9%) missing values	Missing
`crown_diameter` has 12472 (1.9%) missing values	Missing
`height` has 11035 (1.7%) missing values	Missing
`trunk_girth` has 8088 (1.2%) missing values	Missing
`id_management_unit` is highly skewed (γ1 = 120.512582)	Skewed
`trunk_girth` is highly skewed (γ1 = 710.7624047)	Skewed
`description` is uniformly distributed	Uniform
`serial_number` is uniformly distributed	Uniform
`label` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`objectid` has unique values	Unique
`globalid` has unique values	Unique
`housenumber` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`zipcode` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2021-01-05 13:29:19.990535
Analysis finished	2021-01-05 13:30:51.355151
Duration	1 minute and 31.36 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	655650
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	327824.5
Minimum	0
Maximum	655649
Zeros	1
Zeros (%)	< 0.1%
Memory size	5.0 MiB

Quantile statistics

Minimum	0
5-th percentile	32782.45
Q1	163912.25
median	327824.5
Q3	491736.75
95-th percentile	622866.55
Maximum	655649
Range	655649
Interquartile range (IQR)	327824.5

Descriptive statistics

Standard deviation	189269.9963
Coefficient of variation (CV)	0.5773515901
Kurtosis	-1.2
Mean	327824.5
Median Absolute Deviation (MAD)	163912.5
Skewness	1.717475128e-15
Sum	2.149381334e+11
Variance	3.582313151e+10
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
305214	1	< 0.1%
628120	1	< 0.1%
650647	1	< 0.1%
648598	1	< 0.1%
654741	1	< 0.1%
652692	1	< 0.1%
642451	1	< 0.1%
640402	1	< 0.1%
646545	1	< 0.1%
Other values (655640)	655640	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
655649	1	< 0.1%
655648	1	< 0.1%
655647	1	< 0.1%
655646	1	< 0.1%
655645	1	< 0.1%

common_name
Categorical

HIGH CARDINALITY

Distinct	438
Distinct (%)	0.1%
Missing	702
Missing (%)	0.1%
Memory size	5.0 MiB

Plátano de sombra	92721
Olmo de Siberia	57142
Acacia del Japón	45079
Pino piñonero	42000
Falsa acacia	32857
Other values (433)	385149

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Plátano de sombra	92721	14.1%
Olmo de Siberia	57142	8.7%
Acacia del Japón	45079	6.9%
Pino piñonero	42000	6.4%
Falsa acacia	32857	5.0%
Almez	28878	4.4%
Arce negundo	26943	4.1%
Aligustre del Japón	25065	3.8%
Ciruelo púrpura	19840	3.0%
Castaño de indias	16508	2.5%
Other values (428)	267915	40.9%

Frequencies of value counts

Unique

Unique	62 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	40
Median length	15
Mean length	13.85043697
Min length	3

objectid
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	655650
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1669576.487
Minimum	1341750
Maximum	1997555
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	1341750
5-th percentile	1374533.45
Q1	1505663.25
median	1669576.5
Q3	1833488.75
95-th percentile	1964619.55
Maximum	1997555
Range	655805
Interquartile range (IQR)	327825.5

Descriptive statistics

Standard deviation	189270.6633
Coefficient of variation (CV)	0.1133644758
Kurtosis	-1.199996481
Mean	1669576.487
Median Absolute Deviation (MAD)	163913
Skewness	1.208668388e-06
Sum	1.094657824e+12
Variance	3.582338397e+10
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1343344	1	< 0.1%
1993062	1	< 0.1%
1551967	1	< 0.1%
1549918	1	< 0.1%
1556061	1	< 0.1%
1554012	1	< 0.1%
1543771	1	< 0.1%
1541722	1	< 0.1%
1547865	1	< 0.1%
1545816	1	< 0.1%
Other values (655640)	655640	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1341750	1	< 0.1%
1341751	1	< 0.1%
1341752	1	< 0.1%
1341753	1	< 0.1%
1341754	1	< 0.1%

Value	Count	Frequency (%)
1997555	1	< 0.1%
1997552	1	< 0.1%
1997551	1	< 0.1%
1997550	1	< 0.1%
1997545	1	< 0.1%

description
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	654440
Distinct (%)	99.8%
Missing	12
Missing (%)	< 0.1%
Memory size	5.0 MiB

Árbol	28
ccc arbol	17
Arbol ARB_03-10_0000029731	14
Arbol ARB_02-05_0000000481	13
Palmera	9
Other values (654435)	655557

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Árbol	28	< 0.1%
ccc arbol	17	< 0.1%
Arbol ARB_03-10_0000029731	14	< 0.1%
Arbol ARB_02-05_0000000481	13	< 0.1%
Palmera	9	< 0.1%
Arbol ARB_02-04_0000010787	5	< 0.1%
�rbol	4	< 0.1%
Arbol	4	< 0.1%
descripcion de palmacea	4	< 0.1%
descripcion del arbol	4	< 0.1%
Other values (654430)	655536	> 99.9%
(Missing)	12	< 0.1%

Frequencies of value counts

Unique

Unique	653326 ?
Unique (%)	99.6%

Histogram of lengths of the category

Length

Max length	51
Median length	26
Mean length	26.00959201
Min length	2

id_lot
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.884860825
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.485944333
Coefficient of variation (CV)	0.3824961561
Kurtosis	-0.924032141
Mean	3.884860825
Median Absolute Deviation (MAD)	1
Skewness	-0.2060212094
Sum	2547109
Variance	2.20803056
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
4	148234	22.6%
5	131634	20.1%
3	130419	19.9%
6	114149	17.4%
2	88638	13.5%
1	42576	6.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	42576	6.5%
2	88638	13.5%
3	130419	19.9%
4	148234	22.6%
5	131634	20.1%

Value	Count	Frequency (%)
6	114149	17.4%
5	131634	20.1%
4	148234	22.6%
3	130419	19.9%
2	88638	13.5%

lot
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	5.0 MiB

NORESTE	148233
SURESTE	131634
OESTE	130414
SUR	114149
CENTRO-ESTE	88638
Other values (3)	42581

Frequencies
Length

Value	Count	Frequency (%)
NORESTE	148233	22.6%
SURESTE	131634	20.1%
OESTE	130414	19.9%
SUR	114149	17.4%
CENTRO-ESTE	88638	13.5%
CENTRO-OESTE	42574	6.5%
PARQUES FORESTALES	5	< 0.1%
PARQUES HISTÓRICOS	2	< 0.1%
(Missing)	1	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	18
Median length	7
Mean length	6.77132769
Min length	3

id_district
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	11.99168304
Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	12
Q3	16
95-th percentile	20
Maximum	21
Range	20
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.359185486
Coefficient of variation (CV)	0.446908534
Kurtosis	-0.908591753
Mean	11.99168304
Median Absolute Deviation (MAD)	4
Skewness	-0.2268257391
Sum	7862323
Variance	28.72086908
Monotocity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
8	57012	8.7%
16	52513	8.0%
13	46784	7.1%
11	42520	6.5%
17	41140	6.3%
20	40172	6.1%
10	39619	6.0%
15	39321	6.0%
18	36770	5.6%
9	33768	5.2%
Other values (11)	226029	34.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11648	1.8%
2	24169	3.7%
3	15269	2.3%
4	22329	3.4%
5	27003	4.1%

Value	Count	Frequency (%)
21	16224	2.5%
20	40172	6.1%
19	23067	3.5%
18	36770	5.6%
17	41140	6.3%

district
Categorical

Distinct	21
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	5.0 MiB

FUENCARRAL-EL PARDO	57012
HORTALEZA	52513
PUENTE DE VALLECAS	46784
CARABANCHEL	42520
VILLAVERDE	41140
Other values (16)	415679

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
FUENCARRAL-EL PARDO	57012	8.7%
HORTALEZA	52513	8.0%
PUENTE DE VALLECAS	46784	7.1%
CARABANCHEL	42520	6.5%
VILLAVERDE	41140	6.3%
SAN BLAS-CANILLEJAS	40172	6.1%
LATINA	39619	6.0%
CIUDAD LINEAL	39321	6.0%
VILLA DE VALLECAS	36770	5.6%
MONCLOA-ARAVACA	33768	5.2%
Other values (11)	226029	34.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	19
Median length	10
Mean length	11.70815832
Min length	3

id_neighborhood
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	130
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	123.7604309
Minimum	11
Maximum	215
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	11
5-th percentile	26
Q1	86
median	127
Q3	166
95-th percentile	205
Maximum	215
Range	204
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	53.45380678
Coefficient of variation (CV)	0.4319135477
Kurtosis	-0.8724811856
Mean	123.7604309
Median Absolute Deviation (MAD)	40
Skewness	-0.2449853669
Sum	81143279
Variance	2857.309459
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
183	24010	3.7%
166	21555	3.3%
86	16419	2.5%
171	13923	2.1%
116	13089	2.0%
131	12614	1.9%
191	12215	1.9%
134	11955	1.8%
117	11733	1.8%
152	11653	1.8%
Other values (120)	506482	77.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	3737	0.6%
12	2122	0.3%
13	1325	0.2%
14	1821	0.3%
15	1954	0.3%

Value	Count	Frequency (%)
215	3348	0.5%
214	7737	1.2%
213	893	0.1%
212	838	0.1%
211	3408	0.5%

neighborhood
Categorical

HIGH CARDINALITY

Distinct	130
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	5.0 MiB

ENSANCHE DE VALLECAS	24010
VALDEFUENTES	21555
VALVERDE	16419
VILLAVERDE ALTO C.H.	13923
BUENAVISTA	13089
Other values (125)	566652

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
ENSANCHE DE VALLECAS	24010	3.7%
VALDEFUENTES	21555	3.3%
VALVERDE	16419	2.5%
VILLAVERDE ALTO C.H.	13923	2.1%
BUENAVISTA	13089	2.0%
ENTREVÍAS	12614	1.9%
CASCO HISTÓRICO DE VICÁLVARO	12215	1.9%
PALOMERAS SURESTE	11955	1.8%
ABRANTES	11733	1.8%
PUEBLO NUEVO	11653	1.8%
Other values (120)	506482	77.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	28
Median length	10
Mean length	10.926354
Min length	3

classification_path
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	19
Missing (%)	< 0.1%
Memory size	5.0 MiB

JARDINERIA \ ARBOLES \ ARBOL	417777
JARDINERIA \ ARBOLES \ ARBOL_VIARIO	235089
JARDINERIA \ PALMACEAS	2760
JARDINERIA \ ARBOLES	3
JARDINERIA \ TERRIZOS	1

Frequencies
Length

Value	Count	Frequency (%)
JARDINERIA \ ARBOLES \ ARBOL	417777	63.7%
JARDINERIA \ ARBOLES \ ARBOL_VIARIO	235089	35.9%
JARDINERIA \ PALMACEAS	2760	0.4%
JARDINERIA \ ARBOLES	3	< 0.1%
JARDINERIA \ TERRIZOS	1	< 0.1%
OBRA_CIVIL \ ALCORQUES	1	< 0.1%
(Missing)	19	< 0.1%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	35
Median length	28
Mean length	30.48387249
Min length	3

street_type
Categorical

MISSING

Distinct	7
Distinct (%)	9.9%
Missing	655579
Missing (%)	> 99.9%
Memory size	5.0 MiB

CALLE	34
CUESTA	13
PLAZA	10
tipoVia	8
AVENIDA	4
Other values (2)	2

Frequencies
Length

Value	Count	Frequency (%)
CALLE	34	< 0.1%
CUESTA	13	< 0.1%
PLAZA	10	< 0.1%
tipoVia	8	< 0.1%
AVENIDA	4	< 0.1%
AV	1	< 0.1%
Av	1	< 0.1%
(Missing)	655579	> 99.9%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	2.8%

Histogram of lengths of the category

Length

Max length	7
Median length	3
Mean length	3.00026386
Min length	2

streetname
Categorical

MISSING

Distinct	29
Distinct (%)	40.8%
Missing	655579
Missing (%)	> 99.9%
Memory size	5.0 MiB

CUESTA DE LA VEGA	13
Paseo de la Castellana	9
Murillo	9
nombreVia	8
ARROYO DEL OLIVAR	3
Other values (24)	29

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
CUESTA DE LA VEGA	13	< 0.1%
Paseo de la Castellana	9	< 0.1%
Murillo	9	< 0.1%
nombreVia	8	< 0.1%
ARROYO DEL OLIVAR	3	< 0.1%
Puerta del Angel Caido	3	< 0.1%
CALLE SEGOVIA	2	< 0.1%
Calle Rosaleda	2	< 0.1%
HACIENDA DE PAVONES	2	< 0.1%
SANTUARIO DE VALVERDE	1	< 0.1%
Other values (19)	19	< 0.1%
(Missing)	655579	> 99.9%

Frequencies of value counts

Unique

Unique	20 ?
Unique (%)	28.2%

Histogram of lengths of the category

Length

Max length	25
Median length	3
Mean length	3.001302524
Min length	3

housenumber
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	655594
Missing (%)	> 99.9%
Memory size	5.0 MiB

direction_code
Categorical

HIGH CARDINALITY
MISSING

Distinct	68392
Distinct (%)	32.4%
Missing	444722
Missing (%)	67.8%
Memory size	5.0 MiB

CALLE SERRANILLOS DEL VALLE 6	70
CALLE EMBAJADORES 322	57
AVENIDA MAYORAZGO 8	56
CALLE ARROYO FONTARRON 483	53
CALLE DE LA BAHIA DE MALAGA, 18	53
Other values (68387)	210639

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
CALLE SERRANILLOS DEL VALLE 6	70	< 0.1%
CALLE EMBAJADORES 322	57	< 0.1%
AVENIDA MAYORAZGO 8	56	< 0.1%
CALLE ARROYO FONTARRON 483	53	< 0.1%
CALLE DE LA BAHIA DE MALAGA, 18	53	< 0.1%
CALLE RAYO VALLECANO DE MADRID 4	53	< 0.1%
CALLE PINILLAS 48	53	< 0.1%
CALLE VALCARLOS 6	50	< 0.1%
BULEVAR JOSE PRAT 42	49	< 0.1%
RONDA SUR 229	48	< 0.1%
Other values (68382)	210386	32.1%
(Missing)	444722	67.8%

Frequencies of value counts

Unique

Unique	23339 ?
Unique (%)	11.1%

Histogram of lengths of the category

Length

Max length	60
Median length	3
Mean length	9.922306108
Min length	3

zipcode
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	655550
Missing (%)	> 99.9%
Memory size	5.0 MiB

serial_number
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	654407
Distinct (%)	99.8%
Missing	67
Missing (%)	< 0.1%
Memory size	5.0 MiB

ARB_03-10_0000029731	14
ARB_02-05_0000000481	12
3234245	8
PAL_04-21_0000000001	8
ARB_04-21_0000003686	7
Other values (654402)	655534

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
ARB_03-10_0000029731	14	< 0.1%
ARB_02-05_0000000481	12	< 0.1%
3234245	8	< 0.1%
PAL_04-21_0000000001	8	< 0.1%
ARB_04-21_0000003686	7	< 0.1%
ARB_04-21_0000003161	7	< 0.1%
ALAMEDA DE OSUNA (BARAJAS)-87	6	< 0.1%
ALAMEDA DE OSUNA (BARAJAS)-86	6	< 0.1%
ARB_01-01_0000014669	4	< 0.1%
ARB_02-04_0000010787	4	< 0.1%
Other values (654397)	655507	> 99.9%
(Missing)	67	< 0.1%

Frequencies of value counts

Unique

Unique	653289 ?
Unique (%)	99.7%

Histogram of lengths of the category

Length

Max length	29
Median length	20
Mean length	19.99786014
Min length	2

id_management_unit
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	4597
Distinct (%)	2.0%
Missing	423135
Missing (%)	64.5%
Infinite	0
Infinite (%)	0.0%

Mean	911877.4847
Minimum	3
Maximum	9200001973
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	3
5-th percentile	666.6
Q1	3174
median	6423
Q3	99219
95-th percentile	4000421
Maximum	9200001973
Range	9200001970
Interquartile range (IQR)	96045

Descriptive statistics

Standard deviation	76317759.97
Coefficient of variation (CV)	83.69299742
Kurtosis	14523.43721
Mean	911877.4847
Median Absolute Deviation (MAD)	4805
Skewness	120.512582
Sum	2.120251934e+11
Variance	5.824400488e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7297	872	0.1%
99553	824	0.1%
4000433	822	0.1%
4000449	763	0.1%
99472	730	0.1%
4938	715	0.1%
303434	659	0.1%
5019	647	0.1%
307067	643	0.1%
99551	641	0.1%
Other values (4587)	225199	34.3%
(Missing)	423135	64.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	29	< 0.1%
4	57	< 0.1%
5	38	< 0.1%
7	14	< 0.1%
9	27	< 0.1%

Value	Count	Frequency (%)
9200001973	16	< 0.1%
4000954	24	< 0.1%
4000953	15	< 0.1%
4000952	37	< 0.1%
4000949	21	< 0.1%

management_unit
Categorical

HIGH CARDINALITY
MISSING

Distinct	4596
Distinct (%)	2.0%
Missing	423135
Missing (%)	64.5%
Memory size	5.0 MiB

13.Sur, Ronda	872
16. María de las Mercedes de Borbón, Calle	824
18.Cerro Milano, Avenida	822
18.Ensanche de Vallecas, Avenida	763
18.Mayorazgo, Avenida	730
Other values (4591)	228504

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
13.Sur, Ronda	872	0.1%
16. María de las Mercedes de Borbón, Calle	824	0.1%
18.Cerro Milano, Avenida	822	0.1%
18.Ensanche de Vallecas, Avenida	763	0.1%
18.Mayorazgo, Avenida	730	0.1%
13.Miguel Hernández, Avenida	715	0.1%
14.Hacienda de Pavones (Moratalaz), Calle	659	0.1%
8.Monforte de Lemos, Avenida	647	0.1%
5.Serrano (Chamartín), Calle	643	0.1%
16.Francisco Javier Saenz de Oiza, Avenida	641	0.1%
Other values (4586)	225199	34.3%
(Missing)	423135	64.5%

Frequencies of value counts

Unique

Unique	218 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	50
Median length	3
Mean length	10.60364219
Min length	3

id_greenarea
Real number (ℝ_≥0)

MISSING

Distinct	3362
Distinct (%)	0.8%
Missing	235209
Missing (%)	35.9%
Infinite	0
Infinite (%)	0.0%

Mean	118619.602
Minimum	116501
Maximum	120458
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	116501
5-th percentile	116678
Q1	117727
median	118683
Q3	119670
95-th percentile	120295
Maximum	120458
Range	3957
Interquartile range (IQR)	1943

Descriptive statistics

Standard deviation	1162.780398
Coefficient of variation (CV)	0.009802599044
Kurtosis	-1.197063453
Mean	118619.602
Median Absolute Deviation (MAD)	987
Skewness	-0.1717033817
Sum	4.98725441e+10
Variance	1352058.253
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
119846	7347	1.1%
119670	7321	1.1%
119056	7136	1.1%
118992	5650	0.9%
118354	4497	0.7%
120246	3930	0.6%
119136	3491	0.5%
119671	3394	0.5%
119977	2566	0.4%
118062	2547	0.4%
Other values (3352)	372562	56.8%
(Missing)	235209	35.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
116501	21	< 0.1%
116502	63	< 0.1%
116503	11	< 0.1%
116504	5	< 0.1%
116505	10	< 0.1%

Value	Count	Frequency (%)
120458	263	< 0.1%
120456	206	< 0.1%
120455	241	< 0.1%
120454	244	< 0.1%
120453	18	< 0.1%

greenarea
Categorical

HIGH CARDINALITY
MISSING

Distinct	3340
Distinct (%)	0.8%
Missing	235275
Missing (%)	35.9%
Memory size	5.0 MiB

PARQUE DE PRADOLONGO	7347
PARQUE EMPERATRIZ MARIA DE AUSTRIA	7321
CUÑA VERDE LA LATINA	7136
PARQUE ENRIQUE TIERNO GALVAN	5650
PARQUE LINEAL DE PALOMERAS	4497
Other values (3335)	388424

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
PARQUE DE PRADOLONGO	7347	1.1%
PARQUE EMPERATRIZ MARIA DE AUSTRIA	7321	1.1%
CUÑA VERDE LA LATINA	7136	1.1%
PARQUE ENRIQUE TIERNO GALVAN	5650	0.9%
PARQUE LINEAL DE PALOMERAS	4497	0.7%
PARQUE DE PLATA Y CASTAÑAR	3930	0.6%
PARQUE DE LAS CRUCES	3491	0.5%
PARQUE SAN ISIDRO	3394	0.5%
AMPLIACION PARQUE ARROYO POZUELO	2566	0.4%
COL. MARQUES DE SUANCES	2547	0.4%
Other values (3330)	372496	56.8%
(Missing)	235275	35.9%

Frequencies of value counts

Unique

Unique	73 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	73
Median length	17
Mean length	15.76133455
Min length	3

specie_abbreviation
Categorical

HIGH CARDINALITY

Distinct	472
Distinct (%)	0.1%
Missing	21
Missing (%)	< 0.1%
Memory size	5.0 MiB

PDA	92721
UPU	57069
SJA	45079
PPI	42000
RPS	32857
Other values (467)	385903

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
PDA	92721	14.1%
UPU	57069	8.7%
SJA	45079	6.9%
PPI	42000	6.4%
RPS	32857	5.0%
CAU	28718	4.4%
ANE	26943	4.1%
LJA	25065	3.8%
PCP	19840	3.0%
AHI	16508	2.5%
Other values (462)	268829	41.0%

Frequencies of value counts

Unique

Unique	72 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	8
Median length	3
Mean length	3.036376115
Min length	3

specie_name
Categorical

HIGH CARDINALITY

Distinct	471
Distinct (%)	0.1%
Missing	701
Missing (%)	0.1%
Memory size	5.0 MiB

Platanus x hybrida	92721
Ulmus pumila	57069
Sophora japonica	45079
Pinus pinea	42000
Robinia pseudoacacia	32857
Other values (466)	385223

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Platanus x hybrida	92721	14.1%
Ulmus pumila	57069	8.7%
Sophora japonica	45079	6.9%
Pinus pinea	42000	6.4%
Robinia pseudoacacia	32857	5.0%
Celtis australis	28718	4.4%
Acer negundo	26943	4.1%
Ligustrum japonicum	25065	3.8%
Prunus cerasifera subsp. Pissartii	19840	3.0%
Aesculus hippocastanum	16508	2.5%
Other values (461)	268149	40.9%

Frequencies of value counts

Unique

Unique	73 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	40
Median length	16
Mean length	16.94086327
Min length	3

senescence
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	4975
Missing (%)	0.8%
Memory size	5.0 MiB

CADUCIFOLIO	496348
PERENNIFOLIO	154327

Frequencies
Length

Value	Count	Frequency (%)
CADUCIFOLIO	496348	75.7%
PERENNIFOLIO	154327	23.5%
(Missing)	4975	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	12
Median length	11
Mean length	11.17467704
Min length	3

phenological_phase
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	647
Missing (%)	0.1%
Memory size	5.0 MiB

M	357726
J	228645
NC	28230
T	15937
V	15845
Other values (2)	8620

Frequencies
Length

Value	Count	Frequency (%)
M	357726	54.6%
J	228645	34.9%
NC	28230	4.3%
T	15937	2.4%
V	15845	2.4%
D	5160	0.8%
RC	3460	0.5%
(Missing)	647	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.050307329
Min length	1

interference_type
Categorical

MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	628745
Missing (%)	95.9%
Memory size	5.0 MiB

EDIFICIOS	10780
TRANSITO_PEATONAL	4594
NO_ALTA_TENSION	4174
FAROLAS	4105
OTROS	1556
Other values (4)	1696

Frequencies
Length

Value	Count	Frequency (%)
EDIFICIOS	10780	1.6%
TRANSITO_PEATONAL	4594	0.7%
NO_ALTA_TENSION	4174	0.6%
FAROLAS	4105	0.6%
OTROS	1556	0.2%
INVASION_CALZADA	712	0.1%
SENALES	517	0.1%
VISIBILIDAD_TRAFICO	348	0.1%
ALTA_TENSION	119	< 0.1%
(Missing)	628745	95.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	19
Median length	3
Mean length	3.330327156
Min length	3

status
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.0 MiB

OPERATIVO	655464
NO PREPARADO	166
DESAPARECIDO	9
INACTIVO	5
ACTIVO	4

Frequencies
Length

Value	Count	Frequency (%)
OPERATIVO	655464	> 99.9%
NO PREPARADO	166	< 0.1%
DESAPARECIDO	9	< 0.1%
INACTIVO	5	< 0.1%
ACTIVO	4	< 0.1%
NO_PREPARADO	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	12
Median length	9
Mean length	9.000783955
Min length	6

label
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	654408
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	5.0 MiB

Árbol:	67
Árbol: ARB_03-10_0000029731	14
Árbol: ARB_02-05_0000000481	12
Árbol: PAL_04-21_0000000001	8
Árbol: 3234245	8
Other values (654403)	655541

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Árbol:	67	< 0.1%
Árbol: ARB_03-10_0000029731	14	< 0.1%
Árbol: ARB_02-05_0000000481	12	< 0.1%
Árbol: PAL_04-21_0000000001	8	< 0.1%
Árbol: 3234245	8	< 0.1%
Árbol: ARB_04-21_0000003161	7	< 0.1%
Árbol: ARB_04-21_0000003686	7	< 0.1%
Árbol: ALAMEDA DE OSUNA (BARAJAS)-87	6	< 0.1%
Árbol: ALAMEDA DE OSUNA (BARAJAS)-86	6	< 0.1%
Árbol: ARB_01-01_0000014669	4	< 0.1%
Other values (654398)	655511	> 99.9%

Frequencies of value counts

Unique

Unique	653289 ?
Unique (%)	99.6%

Histogram of lengths of the category

Length

Max length	36
Median length	27
Mean length	26.99755357
Min length	7

globalid
Categorical

UNIQUE

Distinct	655650
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.0 MiB

{62019C6B-D31A-4049-9BAC-8B7A395CE557}	1
{83682A1B-088D-4C04-9CA8-E8E48BE3CC86}	1
{EDBCB49D-1923-4385-9AA7-393DD2820D05}	1
{47E8709B-A777-4902-BA23-DEDDA4DC4B67}	1
{D612159F-9E93-467C-950E-8716E3828280}	1
Other values (655645)	655645

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
{62019C6B-D31A-4049-9BAC-8B7A395CE557}	1	< 0.1%
{83682A1B-088D-4C04-9CA8-E8E48BE3CC86}	1	< 0.1%
{EDBCB49D-1923-4385-9AA7-393DD2820D05}	1	< 0.1%
{47E8709B-A777-4902-BA23-DEDDA4DC4B67}	1	< 0.1%
{D612159F-9E93-467C-950E-8716E3828280}	1	< 0.1%
{92AFEB20-8A17-41D3-9CE1-9490E4884E14}	1	< 0.1%
{F845E171-D8B2-47D9-AF5A-A3E073B99EEA}	1	< 0.1%
{4E382CEA-6305-474B-A850-F3CFE2AE1B14}	1	< 0.1%
{FC844079-EFBB-40A2-8752-31A344F8B916}	1	< 0.1%
{59525193-524F-4F1A-9BBB-3189AE52523D}	1	< 0.1%
Other values (655640)	655640	> 99.9%

Frequencies of value counts

Unique

Unique	655650 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	38
Median length	38
Mean length	38
Min length	38

parent
Real number (ℝ_≥0)

Distinct	655479
Distinct (%)	> 99.9%
Missing	132
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	4333269.185
Minimum	1550265
Maximum	4736879
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	1550265
5-th percentile	4033205.85
Q1	4166343.25
median	4333397.5
Q3	4499922.75
95-th percentile	4634058.15
Maximum	4736879
Range	3186614
Interquartile range (IQR)	333579.5

Descriptive statistics

Standard deviation	193581.5932
Coefficient of variation (CV)	0.04467333667
Kurtosis	0.5511935838
Mean	4333269.185
Median Absolute Deviation (MAD)	166794.5
Skewness	-0.1220132158
Sum	2.840535949e+12
Variance	3.747383322e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1550265	27	< 0.1%
3571299	6	< 0.1%
3571318	6	< 0.1%
4736879	3	< 0.1%
3571317	2	< 0.1%
4331948	1	< 0.1%
4300217	1	< 0.1%
4474959	1	< 0.1%
4008597	1	< 0.1%
4379023	1	< 0.1%
Other values (655469)	655469	> 99.9%
(Missing)	132	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1550265	27	< 0.1%
2314126	1	< 0.1%
3571299	6	< 0.1%
3571317	2	< 0.1%
3571318	6	< 0.1%

Value	Count	Frequency (%)
4736879	3	< 0.1%
4667675	1	< 0.1%
4667674	1	< 0.1%
4667673	1	< 0.1%
4667672	1	< 0.1%

crown_diameter
Real number (ℝ_≥0)

MISSING

Distinct	250
Distinct (%)	< 0.1%
Missing	12472
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%

Mean	4.582883012
Minimum	0
Maximum	300
Zeros	1174
Zeros (%)	0.2%
Memory size	5.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	10
Maximum	300
Range	300
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.16200387
Coefficient of variation (CV)	0.6899595434
Kurtosis	948.4969667
Mean	4.582883012
Median Absolute Deviation (MAD)	2
Skewness	13.53498469
Sum	2947609.53
Variance	9.998268476
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	83029	12.7%
4	80636	12.3%
6	66189	10.1%
3	62211	9.5%
1	50584	7.7%
5	50528	7.7%
8	41871	6.4%
7	33242	5.1%
1.5	24741	3.8%
2.5	21631	3.3%
Other values (240)	128516	19.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1174	0.2%
0.1	2	< 0.1%
0.12	1	< 0.1%
0.16	1	< 0.1%
0.2	71	< 0.1%

Value	Count	Frequency (%)
300	1	< 0.1%
250	12	< 0.1%
222	1	< 0.1%
216	1	< 0.1%
206	1	< 0.1%

height
Real number (ℝ_≥0)

MISSING

Distinct	328
Distinct (%)	0.1%
Missing	11035
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	7.645133235
Minimum	0
Maximum	180
Zeros	2692
Zeros (%)	0.4%
Memory size	5.0 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	4.7
median	6.5
Q3	10
95-th percentile	15
Maximum	180
Range	180
Interquartile range (IQR)	5.3

Descriptive statistics

Standard deviation	3.954464038
Coefficient of variation (CV)	0.5172524685
Kurtosis	17.18284069
Mean	7.645133235
Median Absolute Deviation (MAD)	2.5
Skewness	1.419661742
Sum	4928167.56
Variance	15.63778583
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	55304	8.4%
4	51236	7.8%
6	51222	7.8%
7	43393	6.6%
8	38306	5.8%
4.5	35037	5.3%
10	30939	4.7%
9	29662	4.5%
12	28123	4.3%
5.5	27966	4.3%
Other values (318)	253427	38.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2692	0.4%
0.15	1	< 0.1%
0.2	18	< 0.1%
0.25	15	< 0.1%
0.3	7	< 0.1%

Value	Count	Frequency (%)
180	2	< 0.1%
150	1	< 0.1%
119	1	< 0.1%
115	1	< 0.1%
100	1	< 0.1%

trunk_girth
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	427
Distinct (%)	0.1%
Missing	8088
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%

Mean	0.6271860609
Minimum	0
Maximum	5200.65
Zeros	767
Zeros (%)	0.1%
Memory size	5.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0.16
Q1	0.3
median	0.51
Q3	0.84
95-th percentile	1.4
Maximum	5200.65
Range	5200.65
Interquartile range (IQR)	0.54

Descriptive statistics

Standard deviation	6.809921039
Coefficient of variation (CV)	10.85789603
Kurtosis	530729.9944
Mean	0.6271860609
Median Absolute Deviation (MAD)	0.25
Skewness	710.7624047
Sum	406141.86
Variance	46.37502456
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	15134	2.3%
0.4	14584	2.2%
0.3	14419	2.2%
0.25	14191	2.2%
0.35	12102	1.8%
0.5	11708	1.8%
0.45	11690	1.8%
0.18	11398	1.7%
0.6	11280	1.7%
0.15	10140	1.5%
Other values (417)	520916	79.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	767	0.1%
0.01	8	< 0.1%
0.02	20	< 0.1%
0.03	341	0.1%
0.04	200	< 0.1%

Value	Count	Frequency (%)
5200.65	1	< 0.1%
1680.03	1	< 0.1%
180.01	1	< 0.1%
115.04	1	< 0.1%
105	1	< 0.1%

longitude
Real number (ℝ)

Distinct	654363
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-3.677526323
Minimum	-3.837160628
Maximum	-3.534624746
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	-3.837160628
5-th percentile	-3.764460782
Q1	-3.711183683
median	-3.677249244
Q3	-3.638506714
95-th percentile	-3.601519735
Maximum	-3.534624746
Range	0.3025358821
Interquartile range (IQR)	0.07267696925

Descriptive statistics

Standard deviation	0.049064201
Coefficient of variation (CV)	-0.01334163149
Kurtosis	-0.48754484
Mean	-3.677526323
Median Absolute Deviation (MAD)	0.03572588582
Skewness	-0.2022505044
Sum	-2411170.134
Variance	0.00240729582
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3.690673844	42	< 0.1%
-3.60203577	7	< 0.1%
-3.764921695	6	< 0.1%
-3.601116565	5	< 0.1%
-3.602059194	5	< 0.1%
-3.601468746	5	< 0.1%
-3.68543951	5	< 0.1%
-3.602530911	5	< 0.1%
-3.667244	3	< 0.1%
-3.715174599	3	< 0.1%
Other values (654353)	655564	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.837160628	1	< 0.1%
-3.837154852	1	< 0.1%
-3.837117902	1	< 0.1%
-3.837100357	1	< 0.1%
-3.837090058	1	< 0.1%

Value	Count	Frequency (%)
-3.534624746	1	< 0.1%
-3.541041271	1	< 0.1%
-3.552202321	1	< 0.1%
-3.5526718	1	< 0.1%
-3.552710837	1	< 0.1%

latitude
Real number (ℝ_≥0)

Distinct	654363
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.42032618
Minimum	40.33046447
Maximum	40.54245672
Zeros	0
Zeros (%)	0.0%
Memory size	5.0 MiB

Quantile statistics

Minimum	40.33046447
5-th percentile	40.35728356
Q1	40.3831324
median	40.41494847
Q3	40.45503103
95-th percentile	40.49372567
Maximum	40.54245672
Range	0.2119922531
Interquartile range (IQR)	0.07189863076

Descriptive statistics

Standard deviation	0.04360022624
Coefficient of variation (CV)	0.001078670816
Kurtosis	-0.9394558219
Mean	40.42032618
Median Absolute Deviation (MAD)	0.03567175298
Skewness	0.2334187047
Sum	26501586.86
Variance	0.001900979728
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.43876986	42	< 0.1%
40.45372274	7	< 0.1%
40.39844829	6	< 0.1%
40.45361758	5	< 0.1%
40.45370214	5	< 0.1%
40.43027589	5	< 0.1%
40.45379959	5	< 0.1%
40.4537046	5	< 0.1%
40.47455499	3	< 0.1%
40.4164834	3	< 0.1%
Other values (654353)	655564	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.33046447	1	< 0.1%
40.33046604	1	< 0.1%
40.33048855	1	< 0.1%
40.33050403	1	< 0.1%
40.33052823	1	< 0.1%

Value	Count	Frequency (%)
40.54245672	1	< 0.1%
40.54242895	1	< 0.1%
40.54242603	1	< 0.1%
40.5424104	1	< 0.1%
40.54240271	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Unnamed: 0	common_name	objectid	description	id_lot	lot	id_district	district	id_neighborhood	neighborhood	classification_path	street_type	streetname	housenumber	direction_code	zipcode	serial_number	id_management_unit	management_unit	id_greenarea	greenarea	specie_abbreviation	specie_name	senescence	phenological_phase	interference_type	status	label	globalid	parent	crown_diameter	height	trunk_girth	longitude	latitude
0	0	Ciprés común	1341750	Arbol ARB_03-09_0000025633	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE ARMINZA 1	NaN	ARB_03-09_0000025633	11236.0	9.Arminza, Calle	NaN	NaN	CSE	Cupressus sempervirens	PERENNIFOLIO	M	NaN	OPERATIVO	Árbol: ARB_03-09_0000025633	{350951E6-7C45-41D6-B3DD-14CD8337136E}	4598166.0	2.5	4.0	0.42	-3.802841	40.469239
1	1	Ciprés común	1341751	Arbol ARB_03-09_0000025635	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE ARMINZA 3	NaN	ARB_03-09_0000025635	11236.0	9.Arminza, Calle	NaN	NaN	CSE	Cupressus sempervirens	PERENNIFOLIO	M	NO_ALTA_TENSION	OPERATIVO	Árbol: ARB_03-09_0000025635	{70E0BD2A-E981-43EA-AE79-08ABA89240EE}	4598167.0	2.0	7.0	0.60	-3.802714	40.469676
2	2	Morera blanca	1341752	Arbol ARB_03-09_0000025648	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE AZPEITIA 4	NaN	ARB_03-09_0000025648	3929.0	9.Azpeitia, Calle	NaN	NaN	MAL	Morus alba	CADUCIFOLIO	V	NaN	OPERATIVO	Árbol: ARB_03-09_0000025648	{C5029AE0-99A0-47C8-BDD8-7C9DCB6B3318}	4598168.0	6.5	9.5	0.90	-3.813337	40.470171
3	3	Ciprés de Arizona	1341753	Arbol ARB_03-09_0000025203	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE LAMIACO 4	NaN	ARB_03-09_0000025203	4177.0	9.Lamiaco, Calle	NaN	NaN	CAR	Cupressus arizonica	PERENNIFOLIO	M	NaN	OPERATIVO	Árbol: ARB_03-09_0000025203	{B6726857-D54C-48E8-B2E5-D06436551814}	4598169.0	2.0	4.0	0.80	-3.819511	40.473073
4	4	Ciprés de Arizona	1341754	Arbol ARB_03-09_0000025205	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE LAMIACO 4	NaN	ARB_03-09_0000025205	4177.0	9.Lamiaco, Calle	NaN	NaN	CAR	Cupressus arizonica	PERENNIFOLIO	M	NaN	OPERATIVO	Árbol: ARB_03-09_0000025205	{90108F95-7B9C-4A4B-B5D9-9AF528196C68}	4598170.0	2.0	4.0	0.52	-3.819326	40.473022
5	5	Ciprés de Arizona	1341755	Arbol ARB_03-09_0000025243	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE GOBELAS 28	NaN	ARB_03-09_0000025243	3278.0	9.Gobelas, Calle	NaN	NaN	CAR	Cupressus arizonica	PERENNIFOLIO	M	NaN	OPERATIVO	Árbol: ARB_03-09_0000025243	{675F450D-CB45-40BA-BDF2-DAAA3B18E71D}	4598171.0	1.5	3.5	0.47	-3.823501	40.472980
6	6	Plátano de sombra	1341756	Arbol ARB_03-09_0000025300	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE MOTRICO 8	NaN	ARB_03-09_0000025300	5137.0	9.Motrico, Calle	NaN	NaN	PDA	Platanus x hybrida	CADUCIFOLIO	M	NO_ALTA_TENSION	OPERATIVO	Árbol: ARB_03-09_0000025300	{C366E459-E3E7-432B-8934-504FBF7F8D0B}	4598172.0	6.0	16.0	0.80	-3.812312	40.469508
7	7	Plátano de sombra	1341757	Arbol ARB_03-09_0000025302	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE MOTRICO 8	NaN	ARB_03-09_0000025302	5137.0	9.Motrico, Calle	NaN	NaN	PDA	Platanus x hybrida	CADUCIFOLIO	M	NO_ALTA_TENSION	OPERATIVO	Árbol: ARB_03-09_0000025302	{782D203C-94F7-4A11-9EC5-D0CE0FAEF0D1}	4598173.0	7.0	18.0	0.85	-3.812251	40.469527
8	8	Pino piñonero	1341758	Arbol ARB_03-09_0000025353	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE CANTOS NEGROS 3	NaN	ARB_03-09_0000025353	1454.0	9.Cantos Negros, Calle	NaN	NaN	PPI	Pinus pinea	PERENNIFOLIO	M	NaN	OPERATIVO	Árbol: ARB_03-09_0000025353	{0DC9D545-7A70-4AA9-B141-B33F4859D6D7}	4598174.0	4.0	11.0	0.95	-3.832406	40.475828
9	9	Pino piñonero	1341759	Arbol ARB_03-09_0000025368	3	OESTE	9.0	MONCLOA-ARAVACA	96.0	EL PLANTÍO	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	CALLE CANTOS NEGROS 10	NaN	ARB_03-09_0000025368	1454.0	9.Cantos Negros, Calle	NaN	NaN	PPI	Pinus pinea	PERENNIFOLIO	V	NO_ALTA_TENSION	OPERATIVO	Árbol: ARB_03-09_0000025368	{1E1F1282-2C17-4CEF-865A-026B460EF5E0}	4598175.0	7.0	16.0	1.42	-3.833835	40.476243

Last rows

	Unnamed: 0	common_name	objectid	description	id_lot	lot	id_district	district	id_neighborhood	neighborhood	classification_path	street_type	streetname	housenumber	direction_code	zipcode	serial_number	id_management_unit	management_unit	id_greenarea	greenarea	specie_abbreviation	specie_name	senescence	phenological_phase	interference_type	status	label	globalid	parent	crown_diameter	height	trunk_girth	longitude	latitude
655640	655640	NaN	1997540	Arbol plantado	3	PARQUES FORESTALES	3.0	RETIRO	35.0	LOS JERÓNIMOS	JARDINERIA \ ARBOLES \ ARBOL	CALLE	Puerta del Angel Caido	4	Arbol plantado cerca de la estufa 20	28009	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NO PREPARADO	Árbol:	{A393EF62-0131-4677-96E7-39BB8EC99231}	NaN	NaN	NaN	NaN	-3.685364	40.409533
655641	655641	Taray	1997541	NaN	1	PARQUES HISTÓRICOS	3.0	RETIRO	35.0	LOS JERÓNIMOS	JARDINERIA \ ARBOLES \ ARBOL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	TAX	Tamarix sp	CADUCIFOLIO	NaN	NaN	ACTIVO	Árbol:	{34F00624-A2B4-4FCF-BC7D-CDB75784B4B3}	NaN	NaN	NaN	NaN	-3.687617	40.410718
655642	655642	Almez	1997542	Arbol	3	PARQUES FORESTALES	3.0	RETIRO	35.0	LOS JERÓNIMOS	JARDINERIA \ ARBOLES \ ARBOL	CALLE	Puerta del Angel Caido	4	Arbol cercano a la estufa 22	28009	NaN	NaN	NaN	NaN	NaN	CAU	Celtis australis	CADUCIFOLIO	M	OTROS	NO PREPARADO	Árbol:	{358A44ED-5C5E-4FC6-919E-358D4294CAA2}	NaN	8.0	8.5	1.5	-3.685705	40.409201
655643	655643	Taray	1997543	NaN	1	CENTRO-OESTE	1.0	CENTRO	14.0	JUSTICIA	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	NaN	NaN	NaN	3327.0	1.Gran Vía, Calle	NaN	NaN	TAX	Tamarix sp	CADUCIFOLIO	NaN	NaN	NO PREPARADO	Árbol:	{8DD5FC80-4B88-4525-B37E-003C466A4ACB}	4736879.0	NaN	NaN	NaN	-3.700071	40.419945
655644	655644	Taray	1997544	aa	1	CENTRO-OESTE	1.0	CENTRO	16.0	SOL	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	NaN	NaN	NaN	4846.0	1.Mayor, Calle	NaN	NaN	TAX	Tamarix sp	CADUCIFOLIO	NaN	NaN	NO PREPARADO	Árbol:	{25471FE5-8233-424D-9B47-2C3E42427FF0}	4736879.0	NaN	NaN	NaN	-3.706493	40.416332
655645	655645	Taray	1997545	NaN	1	CENTRO-OESTE	1.0	CENTRO	16.0	SOL	JARDINERIA \ ARBOLES \ ARBOL_VIARIO	NaN	NaN	NaN	NaN	NaN	NaN	4846.0	1.Mayor, Calle	NaN	NaN	TAX	Tamarix sp	CADUCIFOLIO	NaN	NaN	NO PREPARADO	Árbol:	{BEF77DC5-A314-4EB9-A594-0D29094317E9}	4736879.0	NaN	NaN	NaN	-3.705335	40.416518
655646	655646	NaN	1997550	Arbol	3	PARQUES FORESTALES	9.0	MONCLOA-ARAVACA	91.0	CASA DE CAMPO	JARDINERIA \ ARBOLES \ ARBOL	CALLE	Calle Rosaleda	2	Cedro en la pradera	28008	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NO PREPARADO	Árbol:	{765A9B8A-A33D-4565-86EF-F4F063A87614}	NaN	NaN	NaN	NaN	-3.721560	40.427335
655647	655647	Cedro llorón	1997551	Arbol	3	PARQUES FORESTALES	9.0	MONCLOA-ARAVACA	91.0	CASA DE CAMPO	JARDINERIA \ ARBOLES \ ARBOL	CALLE	Calle Rosaleda	2	Cedro en la pradera	28008	NaN	NaN	NaN	NaN	NaN	CDE	Cedrus deodara	PERENNIFOLIO	V	NaN	NO PREPARADO	Árbol:	{23F65D09-FF9A-4F42-83A2-82B98E8881ED}	NaN	12.0	23.0	3.7	-3.721560	40.427335
655648	655648	NaN	1997552	Arbol -test-	1	CENTRO-OESTE	1.0	CENTRO	14.0	JUSTICIA	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	116943.0	PZA. DE CIBELES-FUENTE E ISLETAS	NaN	NaN	NaN	NaN	NaN	NO PREPARADO	Árbol:	{577ED854-DCB7-467A-880D-8013B864E0C8}	NaN	NaN	NaN	NaN	-3.693107	40.419355
655649	655649	Almez	1997555	Arbol	3	PARQUES FORESTALES	3.0	RETIRO	35.0	LOS JERÓNIMOS	JARDINERIA \ ARBOLES \ ARBOL	CALLE	Puerta del Angel Caido	4	Arbol cercano a la estufa 22	28009	NaN	NaN	NaN	NaN	NaN	CAU	Celtis australis	CADUCIFOLIO	M	OTROS	NO PREPARADO	Árbol:	{E5DD6387-5E0F-4958-9269-123103E3A1D3}	NaN	8.0	8.5	1.5	-3.685705	40.409201

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows